<?php
$table_type = 'InnoDB';

return array(
    'schema_up' => array(
        "CREATE TABLE IF NOT EXISTS `VeCongTy_settings` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `key` varchar(255) NOT NULL,
          `value` varchar(255) NOT NULL,
          PRIMARY KEY (`id`)
          
        ) ENGINE=$table_type DEFAULT CHARSET=utf8;",
        
        "CREATE TABLE IF NOT EXISTS `VeCongTy_tabs` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `key_name` varchar(255) NOT NULL,
            `name` varchar(255) NOT NULL,
            `value` text,
            `weight` tinyint(4) DEFAULT NULL,
            PRIMARY KEY (`id`)
      ) ENGINE=$table_type DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"
        
    ),
    
    'schema_down' => array(
        'DROP TABLE IF EXISTS `VeCongTy_settings`;',
        'DROP TABLE IF EXISTS `VeCongTy_tabs`;',
    ) 
);

?>